home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
cashboxloc.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
835b
|
23 lines
/* RCSVER $Id: cashboxloc.sql,v 1.2 1999-03-29 16:48:14-06 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
*
* Name: cashboxloc.sql
* Date: 02/23/1999
* memo: Randy Wood
* Description: Create the cashboxloc table. Cashboxloc contains a location
* history for each cashbox.
* Changes:
************************************************************************* */
CREATE TABLE cashboxloc
(
cashbox_glid NUMBER(38),
move_date DATE,
location_glid NUMBER(38),
pstatus NUMBER(38), /* Primary status: In/Out of service */
status NUMBER(38), /* secondary status: counted etc. */
user_id VARCHAR(80),
op_type NUMBER(38),
CONSTRAINT pk_cashboxloc PRIMARY KEY (cashbox_glid, move_date)
);